﻿CREATE PROCEDURE [dbo].[CreatePublisher]
	@publisherName nvarchar(100),
	@city nvarchar(50)
AS
	insert	Publisher (PublisherName, City)
	values	(@publisherName, @city);
	select	CAST(scope_identity() as int) as PublisherId;
RETURN 0